<?php
// no direct access
defined('_JEXEC') or die('Restricted Access');

$db = JFactory::getDBO();
$query = $db->getQuery(true);
$query->select('*');
$query->from('#__shop_category');
$query->where('parent_id = 0');
$query->where('state = 1');
$query->order('ordering ASC');

// Get the options.
$db->setQuery($query);
$options = $db->loadObjectList();

require JModuleHelper::getLayoutPath('mod_joblist', $params->get('layout', 'default'));
?>